//Created By Gaurav Shrestha

report = new com.openbravo.pos.reports.PanelReportBean();

report.setTitleKey("Menu.timeClockSummaryTitle");
report.setReport("/com/openbravo/reports/employeeTimeCardSummary");
report.setResourceBundle("com/openbravo/reports/employeeTimeCardSummary_messages");



report.setSentence("SELECT PEOPLE.NAME, SUM(TIME_TO_SEC(TIMEDIFF(CLOCKINOUT.ClockedOutTime,CLOCKINOUT.ClockedInTime))/3600) as HOUR "+
"FROM CLOCKINOUT, PEOPLE "+
"WHERE CLOCKINOUT.EmployeeID = PEOPLE.ID "+
"AND ?(QBF_FILTER) GROUP BY NAME");

report.addParameter("CLOCKINOUT.ClockedInTime");
report.addParameter("CLOCKINOUT.ClockedOutTime");
report.addQBFFilter(new com.openbravo.pos.reports.JParamsDatesInterval());

report.addField("NAME", com.openbravo.data.loader.Datas.STRING);
report.addField("HOUR", com.openbravo.data.loader.Datas.DOUBLE);

report;

